package demo2.DeleteEmployee;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;

import javax.swing.JTable;

import db.DBUtil;

public class DeleteEmployeeDAO {

	public void delete1(String id) throws SQLException{
		Connection conn=DBUtil.getConnection();
		Statement stmt=conn.createStatement();
		String sql="delete  from result  where e_id='"+id+"'";
		stmt.execute(sql); 
		DBUtil.close(conn);
	}
	
	public  void delete2(String  id) throws SQLException{
		Connection conn=DBUtil.getConnection();
		Statement stmt=conn.createStatement();
		String sql="delete  from emp_info  where emp_id='"+id+"'";
		stmt.execute(sql); 
		DBUtil.close(conn);
	}
}
